package com.cloudpivot.receivales.meetingtemp.repository;


import com.cloudpivot.receivales.meetingtemp.entity.MeetingTempEntity;
import com.cloudpivot.receivales.meetingtemp.entity.MeetingTempItemEntity;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface MeetingTempRepository extends JpaRepository<MeetingTempEntity, String> {

    //主表
    //全市新生儿遗传代谢病和听力 筛查新进展培训班 测试记录
    @Query(nativeQuery = true, value = "select meeting.*,'张三' as userName from i7hb4_meeting_ledger meeting where meetingname=:meetingName")
    MeetingTempEntity getMeetingEntity(@Param(value = "meetingName") String meetingName);

    @Query(nativeQuery = true,value="select * from meeting_ledger_tmp")
    List<String> getMeetingName();

}
